package com.ruoyi.huanghefd.mapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.ruoyi.huanghefd.domain.HighWorkApproveSheet;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

/**
* @author gnplum
* @description 针对表【high_work_approve_sheet(高空作业审批单)】的数据库操作Mapper
* @createDate 2024-12-04 17:24:16
* @Entity com.ruoyi.huanghefd.domain.HighWorkApproveSheet
*/
@Mapper
public interface HighWorkApproveSheetMapper extends BaseMapper<HighWorkApproveSheet> {
    /**
     * @param highWorkApproveSheet
     * @return int
     * @Author gnplum
     * @Description //新增 高空作业审批单
     * @Date 10:28 2024/12/04
     **/
    int insertAll(HighWorkApproveSheet highWorkApproveSheet);
    /**
     * @param hsCode
     * @return int
     * @Author gnplum
     * @Description //删除 高空作业审批单
     * @Date 10:28 2024/12/04
     **/
    int delByHsCode(@Param("hsCode") String hsCode);
    /**
     * @param highWorkApproveSheet
     * @return int
     * @Author gnplum
     * @Description //修改 高空作业审批单
     * @Date 10:28 2024/12/04
     **/
    int updateByHsId(HighWorkApproveSheet highWorkApproveSheet);
    /**
     * @param hsCode,hsDept,hsState,userId,mailType,startIndex,pageSize
     * @return int
     * @Author gnplum
     * @Description //分页查询 高空作业审批单
     * @Date 10:28 2024/12/04
     **/
    List<HighWorkApproveSheet> queryHighWorkApproveSheetByPage(@Param("hsCode") String hsCode, @Param("hsDept") String hsDept, @Param("hsState") String lsState, @Param("userId") String userId, @Param("mailType") String mailType, @Param("startIndex") int startIndex, @Param("pageSize") int pageSize);
    /**
     * @return int
     * @Author gnplum
     * @Description //查询  高空作业审批单  分页总数
     * @Date 2:02 2023/12/20
     **/
    int getHighWorkApproveSheetNum(@Param("hsCode") String hsCode, @Param("hsDept") String hsDept, @Param("hsState") String lsState, @Param("userId") String userId, @Param("mailType") String mailType);
    /**
     * @return int
     * @Author gnplum
     * @Description //获取  审批单编号
     * @Date 16:34 2024/12/4
     **/
    int getHsCodeNum(@Param("PJLX") String PJLX);
    /**
     * @param userId
     * @return int
     * @Author gnplum
     * @Description //获取正在执行票数量
     * @Date 23:50 2024/12/4
     **/
    int getExeSheetNum( @Param("userId") String userId);
}




